package com.friday.dao;

import java.sql.Date;
import java.util.List;

import com.friday.po.VacateApply;

public interface VacateApplyDao {
	
	int insertVacateApply(VacateApply va) throws Exception;
	
	int updateDifferenceByid(VacateApply va) throws Exception;
	
	int deleteById(String id) throws Exception;
	
	VacateApply queryById(String id) throws Exception;
	
	List<VacateApply> queryAll() throws Exception;
	
	List<VacateApply> queryByEmployee(String employee) throws Exception;
	
	List<VacateApply> queryByDepartment(String department) throws Exception;
	
	List<VacateApply> queryByState(int state) throws Exception;
	
	List<VacateApply> queryByEmployeeAndState(String employee, int state) throws Exception;
	
	List<VacateApply> queryByDepartmentAndState(String department, int state) throws Exception;
	
	List<VacateApply> queryByApplyDatePeriod(Date firstday, Date lastday) throws Exception;
	
	

}
